package Dao;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import Bean.joinHadoopBean;

public class ChartDao extends SqlMapClientDaoSupport{
	public int areaSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("seoulSequence");
	}
	
	public int gwangjuSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("gwangjuSequence");
	}
	
	public int degooSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("degooSequence");
	}
	
	public int dejunSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("dejunSequence");
	}
	public int woolsanSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("woolsanSequence");
	}
	
	public int gangwondoSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("gangwondoSequence");
	}
	public int kunggiSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("kunggiSequence");
	}
	public int kungsangSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("kungsangSequence");
	}
	
	public int junradoSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("junradoSequence");
	}
	
	public int choongchungdoSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("choongchungdoSequence");
	}
	
	public int sejongSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("sejongSequence");
	}
	
	public int jejooSequence(){
		return (int)getSqlMapClientTemplate().queryForObject("jejooSequence");
	}
	
	public List<joinHadoopBean> seoulChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("seoulChart", ka_no);
	}
	
	public List<joinHadoopBean> gwangjuChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("gwangjuChart", ka_no);
	}
	
	public List<joinHadoopBean> degooChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("degooChart", ka_no);
	}
	
	public List<joinHadoopBean> dejunChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("dejunChart", ka_no);
	}
	
	public List<joinHadoopBean> woolsanChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("woolsanChart", ka_no);
	}
	
	public List<joinHadoopBean> gangwondoChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("gangwondoChart", ka_no);
	}
	
	public List<joinHadoopBean> kunggiChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("kunggiChart", ka_no);
	}
	
	public List<joinHadoopBean> kungsangChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("kungsangChart", ka_no);
	}
	
	public List<joinHadoopBean> junradoChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("junradoChart", ka_no);
	}
	
	public List<joinHadoopBean> choongchungdoChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("choongchungdoChart", ka_no);
	}
	
	public List<joinHadoopBean> sejongChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("sejongChart", ka_no);
	}
	
	public List<joinHadoopBean> jejooChartList(Integer ka_no){
		return (List<joinHadoopBean>)getSqlMapClientTemplate().queryForList("jejooChart", ka_no);
	}
	
}